Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

gsm_range table — gsmra

This table contains the definitions of ranges for your application’s security controls.

Table 11–7 lists the table’s FLA, fields, and foreign keys.

Table 11–7: gsm_range table information 

Table FLA	Fields (data type)	Foreign keys
gsmra	range_obj (Decimal) range_code (Character) range_description (Character) disabled (Logical) system_owned (Logical)	None

Table 11–8 gives details of the table’s indexes.

Table 11–8: gsm_range index information 

Index name	Elements	Type
XPKgsm_range	range_obj	Primary Unique
XAK1gsm_range	range_code	Unique
XIE1gsm_range	range_description	Nonunique

The range structures control what data specific users can view. When you allocate a range to a user, you are specifying what data the user is permitted to view. The appropriate data is hidden from the user.

Sample range structures might include “Nominal Codes,” “Cost Centers,” or “Member Codes.”

For range security to be activated, entries must be created in the gsm_security_structure table. The gsm_security_structure table is allocated to users and allows the range security to be globally restricted or different in various parts of the application.